![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Oracle ToolsIn addition to its database design tools, Oracle has several development tools to offer. Oracles Power Objects is similar to the third-party tools described later in this chapter. Power Objects is a graphical drag-and-drop tool that includes a small database called BLAZE. You can use this small standalone RDBMS to assist in the development of applications and also for small standalone applications. Power Objects real power comes when you use it as an application development tool. Power Objects is currently available on the Windows and Macintosh platforms. Oracle also offers the traditional Cooperative Development Environment (CDE) tools that have evolved into the Oracle Developer/2000 development tools. These tools have been in production for quite some time on almost all the platforms Oracle supports. Developer/2000 added flexibility that allows you to develop applications across a variety of platforms using the same base code set. The Oracle Developer/2000 tools are described in detail in Chapter 35, Using GUI Builders, along with how to tune the applications developed by these tools. Oracle Power Objects Oracle Power Objects is a standalone, object-oriented development tool you can use to develop client/server applications or standalone applications by using the small BLAZE database provided with it. Oracle Power Objects allows you to drag-and-drop everything. In this manner, you can quickly develop and test small applications. Although Power Objects is great for developing small standalone applications, its real power comes from its use as an application development tool. Power Objects is currently available for Windows and Macintosh. Oracle Developer/2000 Oracle Developer/2000 is a higher-end tool than Power Objects. Oracle Developer/2000 tools are the follow-on to the traditional CDE tools offered by Oracle. The Developer/2000 tools allow you to design graphical applications and then simply compile them to run in a Windows, Macintosh, Motif, or character-based mode. This flexibility allows standardized applications to be deployed across a heterogeneous network of different machines. Third-Party ToolsThird-party tools you can use to facilitate application development include products such as PowerBuilder from PowerSoft, SQLWindows from Gupta, and Delphi from Borland. Each of these tools is very good and can help speed the development of graphical applications in a Windows or Macintosh environment. These tools are all graphical in nature and allow you to build applications from a graphical console in a drag-and-drop fashion. PowerBuilder from PowerSoft PowerBuilder from PowerSoft is by far one of the most popular application development tools. PowerSoft was among the first to introduce these types of products. PowerBuilder comes with ODBC drivers and native drivers that allow you to connect to SQL*Net directly. Using PowerBuilder, you can very quickly prototype and test various applications. SQLWindows from Gupta Guptas SQLWindows is another very popular application development tool. SQLWindows uses a wizard called QuickForms to help in the development process. Using this tool, you can easily and quickly develop a usable application. SQLWindows comes with ODBC drivers and recommends using them as the primary method of connection. The SQLWindows forms tool is very easy to use and can quickly have you building and running applications. Delphi from Borland Delphi is a graphical, drag-and-drop tool that is very easy to use and very powerful. Delphi comes with ODBC drivers and an optional SQL*Net driver. Delphi consists of two main components: the forms developer is simply called Delphi; the reports developer is called ReportSmith. These tools are very easy to learn; you can be up and building applications in just a few hours. These tools connect to your database and extract the data types directly from Oracle without requiring manual insertion of these values. If you have to deploy applications in a short time frame, I recommend that you use these tools. More detailed descriptions of these tools and ideas for more efficiently tuning the resulting application are given in Chapter 35, GUI Builders.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |